GridRowColumnValue (name)

Basic and Crystal syntax.

Arguments

name is a String value which is an Alias for Formulas. The Alias for Formulas is a name you have specified for a level of dimension in an OLAP grid or a cross-tab. See Formatting the grid.

Returns

Value of a level of dimension in an OLAP grid or cross-tab, that has been specified by the argument, name. The type of the value thus depends on the type of the specified dimension.

Action

GridRowColumnValue returns the value of a specified level of dimension in an OLAP grid or cross-tab.

Typical uses

To format cells under a level of dimension in an OLAP grid or cross-tab, based on the value of that level of dimension. For instance, you can format the font color for cells in a level of dimension based on the value of that level of dimension. The attributes of a cell that you can format conditionally using a formula include: font, border, object positioning, etc. They are accessible through the Format Editor. See Conditional attribute properties.

Examples

The following example is applicable to both Crystal and Basic syntax:

Assume an OLAP grid with Products in the rows, and Regions in the columns.

Suppose you would like to use GridRowcolumnValue to conditionally format cells under Level 1 of the Regions dimension and Level 2 of the Products dimension. In particular, you want to format the font color of the total sales of individual products for all of Europe to be red, and that under North America to be blue.

  1. Set up an Alias for Formulas for Level 1 of the Regions dimension to be "Continent". (You can do so using the OLAP Report Expert or Format OLAP Grid Object command. See Formatting the grid.

    After setting up the necessary Alias for Formulas, you can then express the formatting condition as: if GridRowColumnValue("Continent") returns "Europe", then you would like the font color of the cells for each Level 2 input of the Products dimension to be red, otherwise, since there are only two continents in this scenario, the font color should be blue.

  2. Click in the OLAP grid on one of the cells representing total sales for Europe for a particular (Level 2) product.

    The cells for all Level 2 inputs for Products combined with all Level 1 inputs for Regions are also selected. Formatting done to one of these cells will be carried over to all other selected cells.

  3. Use the Format Field command to enter a conditional formatting formula for the selected cells. See Working with conditional formatting.

    In Crystal syntax, you can enter a formula like:

If GridRowColumnValue("Continent") = "Europe" Then crRed Else crBlue

In Basic syntax, the formula will be:

If GridRowColumnValue("Continent") = "Europe" Then formula = crRed Else formula = crBlue

You will see the total sales of individual products for Europe highlighted in red, and the total sales of individual products for North America highlighted in blue.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com